﻿DROP TABLE IF EXISTS `open_exchange_goods`;
CREATE TABLE `open_exchange_goods` (
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `exchange_price` decimal(10,2) unsigned DEFAULT NULL,
  `exchange_integral` int(10) unsigned NOT NULL DEFAULT '0',
  `is_exchange` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `user_rank` varchar(100) DEFAULT NULL,
  `is_stop` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;